{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Folha1","Folha2","Folha3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Folha1","index":0,"n_rows":41,"n_cols":15,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Exemplo. Venda de seguros da Cosmic"]
[null,"Lanç. Moeda","NPA","Result. Moeda","Int. Seguro","Lanç.","NPA","Resultado","Valor Seguro (Mil €)","Valor","Auxiliar1","Auxiliar2","Auxiliar3"]
[null,"N",null,"F=0-0,5; C=0,5-1","S=1;N=0","Dado?","Dado","Dado","\"0\"; \"10\"; \"20\"","€","Venda","Venda=10","Venda=20"]
[null,1,{"$f":"RAND()","v":0.27237599373093857},{"$f":"IF(C5<0.5, \"F\", \"C\")","v":"F"},{"$f":"IF(D5=\"F\", \"Sim\", \"Não\")","v":"Sim"},{"$f":"IF(E5=\"Não\", \"Não\", \"Sim\")","v":"Sim"},{"$f":"IF(F5=\"Não\", \"Não\", RAND())","v":0.48285916690817499},{"$f":"IF(G5=\"Não\",0,IF(G5<1/6,1,IF(G5<2/6,2,IF(G5<3/6,3,IF(G5<4/6,4,IF(G5<5/6,5,6))))))","v":3},{"$f":"IF(H5<4,0, IF(H5<6, 10,20))","v":0},{"$f":"+I5*1000","v":0},{"$f":"IF(I5=0,0, 1)","v":0},{"$f":"IF(I5=10,1, 0)","v":0},{"$f":"IF(I5=20,1, 0)","v":0}]
[null,{"$f":"+B5+1","v":2},{"$f":"RAND()","v":8.2499135962496806E-2},{"$f":"IF(C6<0.5, \"F\", \"C\")","v":"F"},{"$f":"IF(D6=\"F\", \"Sim\", \"Não\")","v":"Sim"},{"$f":"IF(E6=\"Não\", \"Não\", \"Sim\")","v":"Sim"},{"$f":"IF(F6=\"Não\", \"Não\", RAND())","v":0.25873314065886344},{"$f":"IF(G6=\"Não\",0,IF(G6<1/6,1,IF(G6<2/6,2,IF(G6<3/6,3,IF(G6<4/6,4,IF(G6<5/6,5,6))))))","v":2},{"$f":"IF(H6<4,0, IF(H6<6, 10,20))","v":0},{"$f":"+I6*1000","v":0},{"$f":"IF(I6=0,0, 1)","v":0},{"$f":"IF(I6=10,1, 0)","v":0},{"$f":"IF(I6=20,1, 0)","v":0}]
[null,{"$f":"+B6+1","v":3},{"$f":"RAND()","v":0.82659191175552593},{"$f":"IF(C7<0.5, \"F\", \"C\")","v":"C"},{"$f":"IF(D7=\"F\", \"Sim\", \"Não\")","v":"Não"},{"$f":"IF(E7=\"Não\", \"Não\", \"Sim\")","v":"Não"},{"$f":"IF(F7=\"Não\", \"Não\", RAND())","v":"Não"},{"$f":"IF(G7=\"Não\",0,IF(G7<1/6,1,IF(G7<2/6,2,IF(G7<3/6,3,IF(G7<4/6,4,IF(G7<5/6,5,6))))))","v":0},{"$f":"IF(H7<4,0, IF(H7<6, 10,20))","v":0},{"$f":"+I7*1000","v":0},0,0,0]
[null,4,0.82317606892724671,"C","Não","Não","Não",0,0,0,0,0,0]
[null,5,2.2491411579239062E-2,"F","Sim","Sim",0.13484551713161741,1,0,0,0,0,0]
[null,6,0.3598829777051239,"F","Sim","Sim",0.90247322586473078,6,20,20000,1,0,1]
[null,7,0.16782090702022323,"F","Sim","Sim",0.32047561939911873,2,0,0,0,0,0]
[null,8,0.90544536806681208,"C","Não","Não","Não",0,0,0,0,0,0]
[null,9,0.80940549649294047,"C","Não","Não","Não",0,0,0,0,0,0]
[null,10,0.15380030136551326,"F","Sim","Sim",0.75756509949019768,5,10,10000,1,1,0]
[null,11,0.5515868907169843,"C","Não","Não","Não",0,0,0,0,0,0]
[null,12,0.92856461048462313,"C","Não","Não","Não",0,0,0,0,0,0]
[null,13,0.90932994503706288,"C","Não","Não","Não",0,0,0,0,0,0]
[null,14,0.32560641856865835,"F","Sim","Sim",0.12943346311589565,1,0,0,0,0,0]
[null,15,0.56782160786038172,"C","Não","Não","Não",0,0,0,0,0,0]
[null,16,0.85243915627945077,"C","Não","Não","Não",0,0,0,0,0,0]
[null,17,0.73391120651415032,"C","Não","Não","Não",0,0,0,0,0,0]
[null,18,0.21875935370733823,"F","Sim","Sim",0.62173015377588814,4,10,10000,1,1,0]
[null,19,0.19999073013077651,"F","Sim","Sim",0.12021644068221771,1,0,0,0,0,0]
[null,20,0.79025974247175945,"C","Não","Não","Não",0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K5:K24)","v":3},{"$f":"SUM(L5:L24)","v":2},{"$f":"SUM(M5:M24)","v":1}]
[null,null,null,"Comparação de resultados teóricos e resultados simulados"]
[null,null,null,"Probab.","Probab.","Dada uma","Venda "]
[null,null,null,"Venda","Não  Venda","P(venda=10)","P(venda=20)",null,"Valor Esperado",null,"Amostra","P(Venda)","P(V=10/V)","P(V=20/V)","V. Esp"]
[null,"Simulados",null,{"$f":"+K25/B24","v":0.15},{"$f":"1-D29","v":0.85},{"$f":"+L25/K25","v":0.66666666666666663},{"$f":"+M25/K25","v":0.33333333333333331},null,{"$f":"F29*10000+G29*20000","v":13333.333333333332},null,null,{"$f":"AVERAGE(L31:L41)","v":0.21818181818181817},{"$f":"AVERAGE(M31:M41)","v":0.78181818181818175},{"$f":"AVERAGE(N31:N41)","v":0.62391774891774887},{"$f":"AVERAGE(O31:O41)","v":13760.822510822509}]
[null,"teóricos",null,{"$f":"0.5*0.5","v":0.25},{"$f":"0.5+0.5*0.5","v":0.75},{"$f":"+(1/3*1/2)/(1/3*1/2+1/6*1/2)","v":0.66666666666666663},{"$f":"+(1/6*1/2)/(1/3*1/2+1/6*1/2)","v":0.33333333333333331},null,{"$f":"F30*10000+G30*20000","v":13333.333333333332}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"D29","v":0.15},{"$f":"E29","v":0.85},{"$f":"F29","v":0.66666666666666663},{"$f":"I29","v":13333.333333333332}]
[null,null,null,null,null,null,null,null,null,null,1,0.15,0.85,1,10000]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+K32+1","v":2},0.1,0.9,0,20000]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+K33+1","v":3},0.25,0.75,0.2,18000]
[null,null,null,null,null,null,null,null,null,null,4,0.4,0.6,0.625,13750]
[null,null,null,null,null,null,null,null,null,null,5,0.3,0.7,0.66666666666666663,13333.333333333332]
[null,null,null,null,null,null,null,null,null,null,6,0.15,0.85,1,10000]
[null,null,null,null,null,null,null,null,null,null,7,0.15,0.85,0.66666666666666663,13333.333333333332]
[null,null,null,null,null,null,null,null,null,null,8,0.25,0.75,0.8,12000]
[null,null,null,null,null,null,null,null,null,null,9,0.15,0.85,0.66666666666666663,13333.333333333332]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+K40+1","v":10},0.35,0.65,0.5714285714285714,14285.714285714284]

{"sheet":"Folha2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Folha3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}